import xlrd
import xlutils.copy

# 1.workbook
filename = r'../a_datas/result_xlutils.xls'
rb = xlrd.open_workbook(filename)
workbook = xlutils.copy.copy(rb)
# 2.sheet
sheet = workbook.get_sheet(0)
# 3.写入数据
sheet.write(1, 1, 'changed!')
# 4.添加sheet页
workbook.add_sheet('sheetnnn2', cell_overwrite_ok=True)
# 5.save
workbook.save(filename)